
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspSiteUserExtended_INSERT]
(
@userId AS int = null,
@firstName AS nvarchar(50) = null,
@middleName AS nvarchar(50) = null,
@lastName AS nvarchar(50) = null,
@jobId AS int = null,
@jobPosition AS nvarchar(200) = null,
@birthDate AS datetime = null,
@phone1 AS nvarchar(100) = null,
@phone2 AS nvarchar(100) = null,
@icq AS nvarchar(15) = null,
@skype AS nvarchar(100) = null
)
AS

INSERT INTO
  [dbo].[SiteUserExtended]
(
  [UserId],
  [FirstName],
  [MiddleName],
  [LastName],
  [JobId],
  [JobPosition],
  [BirthDate],
  [Phone1],
  [Phone2],
  [ICQ],
  [Skype]
)
VALUES
(
  @userId,
  @firstName,
  @middleName,
  @lastName,
  @jobId,
  @jobPosition,
  @birthDate,
  @phone1,
  @phone2,
  @icq,
  @skype
)

SELECT SCOPE_IDENTITY()

GO
